============================================================================== Simba Apache Drill ODBC Data Connector Release Notes ============================================================================== The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Apache Drill ODBC Connector 1.6.0, as well as the version history. 1.6.0 ======================================================================== Released 2025-04-24 Enhancements & New Features * [DIRAC-1574][DIRAC-1577] Updated operating systems support The connector now supports the following operating systems: - Debian 11 and 12 - RHEL 8 and 9 - SUSE Linux Enterprise Server (SLES) 12 and 15 - Ubuntu 24.04 For a list of supported operating systems, see the Installation and Configuration Guide. * [DIRAC-1589] Updated SEN support The connector now supports SEN version 10.3. Previously, the connector used SEN version 10.2. * Updated third-party libraries The connector now uses the following third-party libraries: - drillclient 1.21.2 (previously 1.19.0) - Expat 2.6.4 (previously 2.6.3) - OpenSSL 3.0.15 (previously 3.0.13) - Protobuf 3.16.3 (previously 3.11.1) - Zookeeper 3.9.3 (previously 3.9.2) * [DIRAC-1675] Updated FIPS support The connector now supports the FIPS (Federal Information Processing Standards) module to ensure various services: security, quality, and processing compatibility. For more information, see the Installation and Configuration Guide. * [DIRAC-1529] Apple M1 Support The connector now supports M1. For more information, see the Installation and Configuration Guide. Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application. * [DIRAC-1260] The connector shows null for missing columns. If the column values are missing in the first batch of records, the connector is unable to determine the data type of the column. As a workaround, do one of the following: - Create a view and cast the missing column to the required data type. - Explicitly cast the missing column. * Drillbit sometimes terminates unexpectedly. Occasionally, a Drillbit will stop working and then drop the connection after running queries for an extended period of time. As a workaround, restart the Drillbit and then open a new connection. You can determine the state of the Drillbit by connecting to it or by clicking "Test" in the DSN Setup dialog box. * ZooKeeper does not accurately detect the status of a Drill cluster. ZooKeeper does not detect the status of the Drillbits within a cluster, so it continues to include non-working Drillbits in the cluster and make the Drillbits available for connections. For example, Drillbits that are unresponsive to Drill client or SQLLine remain as part of the cluster. An unresponsive Drillbit can cause the Drill client to time out and then reconnect to the cluster. To determine which Drillbit in the cluster is causing the issue, check the Drill client logs, which log the details of the most recently attempted Drillbit connections. * In some cases, iODBCTest does not handle SQL_SUCCESS_WITH_INFO correctly. SQL_SUCCESS_WITH_INFO causes iODBCTest to stop retrieving data if the data is one of the following: - Data where the schema has changed - HBase tables that span multiple regions This issue does not occur in other applications. * The .NET TreeView control sometimes automatically selects the first item in the control. Drill Explorer uses the .NET TreeView control, and this issue sometimes causes a false preview of the first table/file/directory in the Schemas pane to appear. The behavior is harmless and does not affect the integrity of any data or operations. For more information about this issue, see the following thread on Stack Overflow: http://stackoverflow.com/questions/800230/windows-forms-treeview-always-selects-a-node-on-focus * Microsoft Excel does not allow reserved keywords to be used as column names. As a workaround, do one of the following: - Create a SQL view using non-reserved keywords as column names. - In the Data Connection Wizard in Excel, before retrieving the data, modify the SQL query to add back quotes (`) around the column name. - Use Microsoft Query to retrieve non-problematic columns and then modify the query to add the columns with the reserved names, surrounding the new column names in back quotes (`). * On macOS, Microsoft Query does not use schemas when executing queries in the Query View. As a workaround, specify a default schema in the DSN configuration. However, when working in the Query View, you can only query tables that have the specified schema. As an alternative workaround, you can write the queries manually and execute them in the SQL View. * On macOS, the Query View in Microsoft Query shows tables but not views. The macOS version of the connector automatically casts view types into table types for SQLTables calls. * Microsoft SQL Server Linked Server compares metadata from SQLPrepare with metadata from the actual query execution, causing mismatches. When working with views from SELECT * queries, DFS files, and HBase tables, the column metadata from Drill reports the data type to be ANY. As a result, the metadata will not match and queries will fail. As a workaround, create views and explicitly state column types. This issue does not occur with views where the column types are specified. * Microsoft Query does not call SQLDoCloseCursor() or SQLFreeStmt() when executing subsequent queries. As a result of this issue, resources from the previous query are not cleaned up, which may lead to "out of memory" errors if many queries are executed. * SAP Lumira requires views to work with HBase. In SAP Lumira, HBase data is collapsed into single columns and not returned properly. To work with HBase data, create views and execute queries against those views. * SAP Lumira reports "acquisition failed" error. The Drill ODBC SAP Lumira Extension requires some DLLs as dependencies. This issue occurs if the dependencies are missing. To resolve this issue, download and install the Microsoft Visual Studio C++ Redistributable, which contains the necessary libraries. * Parameterized queries are not supported. You cannot use queries that contain parameters. * The Windows version of the connector returns an error when connecting to a local ZooKeeper quorum. To resolve this issue, add the IP address of the ZooKeeper quorum to the Windows hosts file. The connector will be able to connect to the local ZooKeeper quorum successfully. * The Disable ASYNC option affects all DSNs. Using the Disable ASYNC option disables asynchronous operation for all DSNs. Workflow Changes ============================================================= The following changes may disrupt established workflows for the connector. 1.6.0 ------------------------------------------------------------------------ * [DIRAC-1574] Removed support for earlier versions of Linux distributions Beginning with this release, the connector no longer supports the following versions of Linux distributions: - CentOS 7 - Debian 10 - RHEL 7 For a list of supported Linux versions, see the Installation and Configuration Guide. 1.5.4 ------------------------------------------------------------------------ * Removed support for CentOS 6, RHEL 6, and Ubuntu 14.04 Beginning with this release, support for CentOS 6, RHEL 6, and Ubuntu 14.04 has been removed. For a list of supported Linux versions, see the Installation and Configuration Guide. Version History ============================================================== 1.5.14 ----------------------------------------------------------------------- Released 2024-08-06 Enhancements & New Features * Updated Zookeeper library The connector now supports Zookeeper 3.9.2. Previously, the connector used 3.4.6. 1.5.12 ----------------------------------------------------------------------- Released 2024-07-16 Enhancements & New Features * Internal connector improvements The connector has been updated with minor internal improvements. 1.5.11 ----------------------------------------------------------------------- Released 2024-05-20 Enhancements & New Features * [DIRAC-1561] Upgraded Visual Studio support The connector now uses Windows Visual Studio 2022. For supported versions, see the Installation and Configuration Guide. * [DIRAC-1562] Updated third-party libraries The connector now uses the following third-party libraries: - Expat 2.6.2 (previously 2.2.9) - OpenSSL 3.0.13 (previously 3.0.0) * Updated security flags The following security flags have been used to improve security checks in the connector: - /CETCOMPAT - /guard:cf - /Qspectre - /SDL 1.5.10 ----------------------------------------------------------------------- Released 2023-11-30 Enhancements & New Features * Updated third-party libraries The connector now uses the following third-party libraries: - Boost 1.81.0 (previously 1.68.0) - ICU 71.1.x (previously 58.3.x) - OpenSSL 3.0.9 (previously 1.1.1) - SEN 10.2 Resolved Issues The following issue has been resolved in Simba Apache Drill ODBC Connector 1.5.10. * [DIRAC-1502] The connector rounds large integers incorrectly. This issue has been resolved. The connector now converts string values to double using the standard library. 1.5.9.1009 ------------------------------------------------------------------- Released 2022-09-21 Enhancements & New Features * [DIRAC-1493] Updated OpenSSL library The connector now supports OpenSSL 1.1.1q. Previously, the connector used 1.1.1n. 1.5.7.1000 ------------------------------------------------------------------- Released 2022-05-18 Enhancements & New Features * [DIRAC-1482] Support for Ubuntu 20.04 The connector now supports Ubuntu 20.04. For a list of supported operating systems, see the Installation and Configuration Guide. 1.5.6.1006 ------------------------------------------------------------------- Released 2022-04-15 Enhancements & New Features * [DIRAC-1469][DIRAC-1481] Updated third-party libraries The connector now uses the following versions of these third-party libraries: - OpenSSL 1.1.1n (previously 1.1.1l) - Cyrus SASL 2.1.28 (previously 2.1.26) 1.5.5.1004 ------------------------------------------------------------------- Released 2022-01-10 Enhancements & New Features * [DIRAC-1438] Improved description of NumberOfPrefetchBuffers The description of the NumberOfPrefetchBuffers property has been improved to include more details. For more information, see the Installation and Configuration Guide. * [DIRAC-1459] Internal connector improvements The connector has been updated with minor internal improvements. ==============================================================================